2014-12-02 - 15967 - Spec - Japan Retail and Web report #CrystalReportDevelopment
SPECIFICATION
15967 - Japan Retail and Web report
Requirement Summary
Need to develop a new report for Japan Retail and Web information report.
Admin Info
| Purpose |
Need to develop a new report for Japan Retail and Web report. |
| Requested By |
Marli Krebs |
| Spec Created By |
Dhananjay G |
| Spec Created Date |
12/02/2014 |
| Spec QA by |
Uday Kumar P |
| Objects |
Japan Retail & Web Report |
| Document Status |
Complete |
Estimates
| SNo |
Activity |
Estimation in Hours |
| 1 |
Research |
00 |
| 2 |
Documentation |
08 |
| 3 |
Development/Config |
08 |
| 4 |
Unit test in DEV |
08 |
| 5 |
Unit test in QUA |
08 |
| 6 |
BEx & Transports |
08 |
| TOTAL |
40 |
References
Prior Tickets
NoneDocuments
NoneSpec Changes
| SNo |
Change Details |
Requested By |
Requested On |
Notes if any |
Functional Requirement
Purpose/WHY:
Need to create a report that will provide retail and web information for Japan.In Scope:
Retail and Web information only for Japan region for specified Stores.Out of Scope:
Other Regions.Solution Summary
1. Need to create BEx Query for Japan Retail and Web information report.
2. Need to move transports to BPQ & BPP.
3. Need to add the fields like Invoice date, Store Name, Sales Quantity, Total Sales Revenue in the report.
4. Need to add invoice date parameter to show the values with corresponding date in the report.
Test Plan
| Test ID |
Test Scenario |
Expected Results |
| 1 |
Report Format. |
Should be as per NEC crystal standard checklist. |
| 2 |
Execute Crystal Report in Crystal Designer tool after changes. |
Report should execute successfully in Crystal Designer tool. |
| 3 |
Schedule the Report in NEC BI Launch Pad. |
Report should execute successfully in NEC BI Launch Pad. |
Solution Details
1. Need to create BEx Query for Japan Retail and Web information report.
2. Need to move transports to BPQ & BPP.
3. The report that will display the quantity and daily sales (in Yen) by location (Text) as well as the date.
4. Need to run the report on schedule to display the current (previous day) total and also allow it to run manually for the user to pull previous date information.
5. Need to add the fields like Invoice date, Store Name, Sales Quantity and Total Sales Revenue in the report.
6. Need to add invoice date parameter to show the values with corresponding date in the report.
7. After completion of development reports are saved and scheduled into the BOBJ Production Server.
8. Mockup of the report required by NEC is shown below:
Issues
None